UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'doxvDDJ+CLTHT19SqJG34vmPGmH3B+b8si/4qxG85Ss='
WHERE
key_id = '1b50f29b271adc91ab6904d6e2971ee94023c8d90285555c06b6922e101ccf24'
AND (
token = 'doxvDDJ+CLTHT19SqJG34vmPGmH3B+b8si/4qxG85Ss='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)