UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'fV6yVR5OyBmIl2d0B76xCgsePLo8ITpbuzH2R40cjVA='
WHERE
key_id = '0fc6b10e4707510fc2aa8d434d9ca1d0e714ae0cf8105e59abd295dd45c43606'
AND (
token = 'fV6yVR5OyBmIl2d0B76xCgsePLo8ITpbuzH2R40cjVA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)