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