UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pZ5vq8bimIeK647Jazzg2E40RIiQZ8FiTmPpayE9KCw='
WHERE
key_id = 'cb9c4cce245da75376d0f50f745eed6ab39c5e80d43ee06cc42364649c0eeca7'
AND (
token = 'pZ5vq8bimIeK647Jazzg2E40RIiQZ8FiTmPpayE9KCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)