UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '27iw6gzVtlx9t7SzsSe7van+6Eu0G6q/mFvHd0S1FDg='
WHERE
key_id = 'b84ab3e43101b910575874c7d03c23ac83ca0105dc2b177b86aebf8ada1ee83b'
AND (
token = '27iw6gzVtlx9t7SzsSe7van+6Eu0G6q/mFvHd0S1FDg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)