UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'duYQIdjb/q1umMO9+1tbJRAeIaTXixqwvtc3OMtxwqY=' 
WHERE 
  key_id = '17648ad9e2d9a21b54526151b033564e2b4ac63b1747100cb5f0a2ca48d7908e' 
  AND (
    token = 'duYQIdjb/q1umMO9+1tbJRAeIaTXixqwvtc3OMtxwqY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00033