UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LUl5/kHfBc2BzNZ7pOnuoopIeP50miEntny2TI+mFOU=' 
WHERE 
  key_id = '3d9b20360ac40302393fc0531fa8e9cc3f6117a310b3387e88151a5c7b2e7675' 
  AND (
    token = 'LUl5/kHfBc2BzNZ7pOnuoopIeP50miEntny2TI+mFOU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00039