UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KvOkGGsA1sMSyJp5nVqRjYLSsSPFWuG5SbPeZG9kYVU='
WHERE
key_id = 'caf53c2a35ee758e55824b551c9e672c7a6efe08f412244542bd50c3296c8791'
AND (
token = 'KvOkGGsA1sMSyJp5nVqRjYLSsSPFWuG5SbPeZG9kYVU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)