UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/1fUa6sKgwKJKyAGJmJL50sExg4z1dADhTMuvLtXZFs='
WHERE
key_id = '520ee420ded6ad17805130487d40272e739500043e22a39802e76b7c4abdb1b6'
AND (
token = '/1fUa6sKgwKJKyAGJmJL50sExg4z1dADhTMuvLtXZFs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)