UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q0/7QkEaKpSTCoiEkr52WwyVkOkBfZgavKWtD7WdDwU='
WHERE
key_id = '533c9053498616a1b8d75b1fc7e7de74be564502ca9190229f02484e8928ad2c'
AND (
token = 'q0/7QkEaKpSTCoiEkr52WwyVkOkBfZgavKWtD7WdDwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)