UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e4y9JW4dpOYNgD5gC7VrXlolRb42+1bOeWNpi61pnak='
WHERE
key_id = 'f6635dde2a121d6e900a9a0dc329158700b6490ae8a9cca393379dbb383b9a1b'
AND (
token = 'e4y9JW4dpOYNgD5gC7VrXlolRb42+1bOeWNpi61pnak='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)