UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/8tnrbUUW9dJJlhmLNFxt7ltato0Q6UeFv/2y8jKCKw='
WHERE
key_id = '66fa28a015bc2a2b0bac8976401d36ef94fa7e35f98383b7b18d90364920c905'
AND (
token = '/8tnrbUUW9dJJlhmLNFxt7ltato0Q6UeFv/2y8jKCKw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)