UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tmROpAqjJ0LVrYq+yczlG255q7B+lJ7vwQIRVmmPCL0='
WHERE
key_id = '0cf69c27dadcfc2c32abf1a76ea1b768db7ef4b5fb434f1d597f19e89b4ec700'
AND (
token = 'tmROpAqjJ0LVrYq+yczlG255q7B+lJ7vwQIRVmmPCL0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)