UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vnO5sZnQ+4HOJRYRijea5mJwBBd3AzbZUB/+TXdpek4='
WHERE
key_id = '0530a9accb9844c089c955ef117df9bd56b9fd5e091a94684af012f6fccbe34f'
AND (
token = 'vnO5sZnQ+4HOJRYRijea5mJwBBd3AzbZUB/+TXdpek4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)