UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nHMPlAJGw7F1HLin5qb9t6Ho7b6n06cG+f/NtH1HFy0='
WHERE
key_id = 'edaef9c6b8fab203b7425b43913b0c9661d10835f9668e8400d146f4979aebbc'
AND (
token = 'nHMPlAJGw7F1HLin5qb9t6Ho7b6n06cG+f/NtH1HFy0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)