UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bES6iewodXN+aZMOWR8J9cZTIH7ehVd59oAPu3GZPtU='
WHERE
key_id = 'b234ed495a9e66c39344a6d284e485eccc0caa3c1a36a640f5aaf749d4d60349'
AND (
token = 'bES6iewodXN+aZMOWR8J9cZTIH7ehVd59oAPu3GZPtU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)