UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sfdcnpltKIqFMNgbNT8dDRDKe76rOeQmrYJtKV8zRWA='
WHERE
key_id = 'afd5ae4505ad20aa06bde76c1d249802d3ea32e44b83159ad7f5f1e37f0d02d5'
AND (
token = 'sfdcnpltKIqFMNgbNT8dDRDKe76rOeQmrYJtKV8zRWA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)