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