UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nYFLXk/04b5tqDw7mRnSOzzDmT+1BkSjaoElZY1kPns='
WHERE
key_id = '5824bf20209ae2814f411bbf4b9819aac6863b2416a33af575e5b8fffea9f52b'
AND (
token = 'nYFLXk/04b5tqDw7mRnSOzzDmT+1BkSjaoElZY1kPns='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)