UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7qxfs0+CigENuGUv/BMDV5mhj40k3KbgPZ7gxDh1j7M='
WHERE
key_id = '0f5d0785efb905b31a91f513083a542844c5ad55fc6e9d50be0af574512ec1f8'
AND (
token = '7qxfs0+CigENuGUv/BMDV5mhj40k3KbgPZ7gxDh1j7M='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)