UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7NDuZpi4yyqlWm20PIEsa1AloJ7hkvrzITp6xEQa8K4='
WHERE
key_id = 'a688621f5a36c090d996a9efd988cf94a56eb570b4bc32a2e4358a2d7fff01a0'
AND (
token = '7NDuZpi4yyqlWm20PIEsa1AloJ7hkvrzITp6xEQa8K4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)