UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xQerz8w0iitEBcVTsFOcMFmRO0ksVerAOWbVDa/lb3k='
WHERE
key_id = '665db0c93df8e21e38a719c60ade08c162e8ccdb2a8185c8160a1dd49fa4d267'
AND (
token = 'xQerz8w0iitEBcVTsFOcMFmRO0ksVerAOWbVDa/lb3k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)