UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'HBHVyCZt0Ls5IVIqgfygU5clSRl/rX/BfURqfFxxRPY=' 
WHERE 
  key_id = '8043672b85f8315960c4e82d6305db9dff21f1d857c7e59d4980fd1aeae769ae' 
  AND (
    token = 'HBHVyCZt0Ls5IVIqgfygU5clSRl/rX/BfURqfFxxRPY=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00154