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