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