UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ybS/Bp4u0AU45Vof5PTZLBDUivNd17Ac0Y9CkM4tLwg=' 
WHERE 
  key_id = '18cf2504ca31cdd0d5bba9f9f293cfbd27d566d2cde6739f5a65cc74d31ab166' 
  AND (
    token = 'ybS/Bp4u0AU45Vof5PTZLBDUivNd17Ac0Y9CkM4tLwg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00022