UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g1/VNrN9YFui1JbQHG1L7feaWuTuC7obVr202V3jwWw='
WHERE
key_id = '7be76ea174f8590ad1faf8c8e67dd1185d147ea526f22e81bf60ce159780dd4e'
AND (
token = 'g1/VNrN9YFui1JbQHG1L7feaWuTuC7obVr202V3jwWw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)