UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BE7CNPPJtzOlS8O7A5Kv7fGfTuvChWGRryQlMAZxYto='
WHERE
key_id = '9140dfaa3643ba74f4c2aadd36587ca38c3cacbf980af2bdd39af7209f8c2a10'
AND (
token = 'BE7CNPPJtzOlS8O7A5Kv7fGfTuvChWGRryQlMAZxYto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)